North Carolina Admin Review

Reports > Eligibility > North Carolina DPI

The North Carolina DPI extract is configured specifically for exporting NSLP claim data to upload into North Carolina's claim site.

A screenshot showing how to execute the NC DPI extract as described on this page.

  1. Name - enter a report name
    Default: North Carolina DPI

    Template (not pictured) - select a report template

  2. Reset - click to reset to defaults

  3. Building - filter by school(s)

  4. Date Range - select a date range for the claim data

  5. Save as Template - click to save the selected filters and columns as a template

    A screenshot of the edit template modal as described on this page.

    1. Name - enter a template name

    2. Public - check to make the template available to other users

    3. Security Roles - select the security roles that can access a Public template

    4. Cancel - click to return to the previous screen without saving the template

    5. Save - click to save the template

  6. Reset - click to reset to defaults

  7. Request Report - click to request report

    Note: Report will appear in the bell icon when complete

Report Format

The resulting report is a TEXT file formatted to match the following specifications:

1. Upload Form ID

2. Serial Number

3. Process Date

4. Sponsor Name

5. Agreement Number

6. Site Name

7. Site ID/NB

8. Claim Month

9. Claim Year

10. Number of Children Approved for Free Meals

11. Number of Children Approved for Reduced Price Meals

12. Number of Enrolled Children

13. Authorized Sites Participating

14. Total Monthly Attendance

15. Number of Operating Days

16. Free Reimbursable Lunches Served

17. Reduced Price Reimbursable Lunches Served

18. Paid Reimbursable Lunches Served

19. Total Lunches Served

20. Authorized Sites Participating

21. Total Monthly Attendance

22. Number of Operating Days

23. Free Reimbursable Breakfasts Served

24. Reduced Price Reimbursable Breakfasts Served

25. Paid Reimbursable Breakfasts Served

26. Total Reimbursable Breakfasts Served

27. Authorized Sites Participating (Severe-Need)

28. Total Monthly Attendance

29. Number of Operating Days (Severe-Need)

30. Free Reimbursable Breakfasts Served (Severe-Need)

31. Reduced Price Reimbursable Breakfasts Served (Severe-Need)

32. Paid Reimbursable Breakfasts Served (Severe-Need)

33. Total Reimbursable Breakfasts Served (Severe-Need)

34. Number of Children Approved for Free Snacks

35. Number of Children Approved for Reduced Snacks

36. Number of Enrolled Children

37. Authorized Sites Participating

38. Total Monthly Attendance

39. Number Operating Days

40. Free Snacks Served

41. Reduced Snacks Served

42. Paid Snacks Served

43. Total Snacks Served

44. Number of Children Approved for Free Snacks (Area Eligible)

45. Number of Enrolled Children

46. Authorized Sites Participating

47. Total Monthly Attendance

48. Number Operating Days

49. Free Snacks Served (Area Eligible)

50. Total Snacks Served (Area Eligible)

51. Number of Fluid Milk 1/2 Pints Purchased

52. Total Cost of Fluid Milk Purchased This Month

53. Authorized Sites Participating

54. Total Monthly Attendance

55. Number Operating Days

56. Free Milk Served

57. Paid Milk Served

58. Total Milk Served

59. Provision Type - Lunch

60. Provision Type - Breakfast